﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DSHoSo" targetNamespace="http://tempuri.org/DSHoSo.xsd" xmlns:mstns="http://tempuri.org/DSHoSo.xsd" xmlns="http://tempuri.org/DSHoSo.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="QLKDConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QLKDConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLKDMain.Properties.Settings.GlobalReference.Default.QLKDConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="QLKDConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QLKDConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLKDMain.Properties.Settings.GlobalReference.Default.QLKDConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HoSoDangKyTableAdapter" GeneratorDataComponentClassName="HoSoDangKyTableAdapter" Name="HoSoDangKy" UserDataComponentName="HoSoDangKyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="QLKDConnectionString (Settings)" DbObjectName="QLKD.dbo.HoSoDangKy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [HoSoDangKy] WHERE (([ID] = @Original_ID) AND ([NamHoSo] = @Original_NamHoSo) AND ([SoTT] = @Original_SoTT) AND ([DiaBanID] = @Original_DiaBanID) AND ([SoHoSo] = @Original_SoHoSo) AND ([LoaiHoSoID] = @Original_LoaiHoSoID) AND ([NgayCap] = @Original_NgayCap) AND ([TenCoSoKD] = @Original_TenCoSoKD) AND ([SoGiayPhepKD] = @Original_SoGiayPhepKD) AND ([NgayCapPhepKD] = @Original_NgayCapPhepKD) AND ((@IsNull_CoQuanCapKD = 1 AND [CoQuanCapKD] IS NULL) OR ([CoQuanCapKD] = @Original_CoQuanCapKD)) AND ((@IsNull_DiaDiem_KD1 = 1 AND [DiaDiem_KD1] IS NULL) OR ([DiaDiem_KD1] = @Original_DiaDiem_KD1)) AND ((@IsNull_DiaDiem_KD2 = 1 AND [DiaDiem_KD2] IS NULL) OR ([DiaDiem_KD2] = @Original_DiaDiem_KD2)) AND ((@IsNull_ChuCoSo = 1 AND [ChuCoSo] IS NULL) OR ([ChuCoSo] = @Original_ChuCoSo)) AND ((@IsNull_AnhDaiDien = 1 AND [AnhDaiDien] IS NULL) OR ([AnhDaiDien] = @Original_AnhDaiDien)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_SoCMND = 1 AND [SoCMND] IS NULL) OR ([SoCMND] = @Original_SoCMND)) AND ((@IsNull_NgayCapCMND = 1 AND [NgayCapCMND] IS NULL) OR ([NgayCapCMND] = @Original_NgayCapCMND)) AND ((@IsNull_DonViCap = 1 AND [DonViCap] IS NULL) OR ([DonViCap] = @Original_DonViCap)) AND ((@IsNull_DanTocID = 1 AND [DanTocID] IS NULL) OR ([DanTocID] = @Original_DanTocID)) AND ((@IsNull_QuocTichID = 1 AND [QuocTichID] IS NULL) OR ([QuocTichID] = @Original_QuocTichID)) AND ((@IsNull_DienThoai = 1 AND [DienThoai] IS NULL) OR ([DienThoai] = @Original_DienThoai)) AND ((@IsNull_HK_ThuongTru = 1 AND [HK_ThuongTru] IS NULL) OR ([HK_ThuongTru] = @Original_HK_ThuongTru)) AND ((@IsNull_HienO = 1 AND [HienO] IS NULL) OR ([HienO] = @Original_HienO)) AND ((@IsNull_DiaChi = 1 AND [DiaChi] IS NULL) OR ([DiaChi] = @Original_DiaChi)) AND ((@IsNull_MoHinhID = 1 AND [MoHinhID] IS NULL) OR ([MoHinhID] = @Original_MoHinhID)) AND ((@IsNull_NganhNgheID = 1 AND [NganhNgheID] IS NULL) OR ([NganhNgheID] = @Original_NganhNgheID)) AND ((@IsNull_TrangThaiHS = 1 AND [TrangThaiHS] IS NULL) OR ([TrangThaiHS] = @Original_TrangThaiHS)) AND ((@IsNull_NgayNghiKD = 1 AND [NgayNghiKD] IS NULL) OR ([NgayNghiKD] = @Original_NgayNghiKD)) AND ((@IsNull_TrangThai = 1 AND [TrangThai] IS NULL) OR ([TrangThai] = @Original_TrangThai)) AND ((@IsNull_TongSoTang = 1 AND [TongSoTang] IS NULL) OR ([TongSoTang] = @Original_TongSoTang)) AND ((@IsNull_TongSoPhong = 1 AND [TongSoPhong] IS NULL) OR ([TongSoPhong] = @Original_TongSoPhong)) AND ((@IsNull_TongSoNhanVien = 1 AND [TongSoNhanVien] IS NULL) OR ([TongSoNhanVien] = @Original_TongSoNhanVien)) AND ((@IsNull_TongSoCO2 = 1 AND [TongSoCO2] IS NULL) OR ([TongSoCO2] = @Original_TongSoCO2)) AND ((@IsNull_TongSoBinhBot = 1 AND [TongSoBinhBot] IS NULL) OR ([TongSoBinhBot] = @Original_TongSoBinhBot)) AND ((@IsNull_TongSoLangVoi = 1 AND [TongSoLangVoi] IS NULL) OR ([TongSoLangVoi] = @Original_TongSoLangVoi)) AND ((@IsNull_TongSoMayBom = 1 AND [TongSoMayBom] IS NULL) OR ([TongSoMayBom] = @Original_TongSoMayBom)) AND ((@IsNull_TongSoNguoi = 1 AND [TongSoNguoi] IS NULL) OR ([TongSoNguoi] = @Original_TongSoNguoi)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NamHoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamHoSo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoTT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoTT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DiaBanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaBanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoHoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoHoSo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LoaiHoSoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoaiHoSoID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayCap" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenCoSoKD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenCoSoKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SoGiayPhepKD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoGiayPhepKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayCapPhepKD" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCapPhepKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CoQuanCapKD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoQuanCapKD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CoQuanCapKD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CoQuanCapKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaDiem_KD1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaDiem_KD1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaDiem_KD1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaDiem_KD1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaDiem_KD2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaDiem_KD2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaDiem_KD2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaDiem_KD2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChuCoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChuCoSo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ChuCoSo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChuCoSo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnhDaiDien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnhDaiDien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AnhDaiDien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnhDaiDien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoCMND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoCMND" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SoCMND" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoCMND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayCapCMND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayCapCMND" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayCapCMND" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCapCMND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DonViCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DonViCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DonViCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DanTocID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DanTocID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DanTocID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DanTocID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QuocTichID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuocTichID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuocTichID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuocTichID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DienThoai" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HK_ThuongTru" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HK_ThuongTru" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HK_ThuongTru" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HK_ThuongTru" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HienO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HienO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HienO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HienO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MoHinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MoHinhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MoHinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MoHinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NganhNgheID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NganhNgheID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NganhNgheID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NganhNgheID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrangThaiHS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThaiHS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TrangThaiHS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TrangThaiHS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayNghiKD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayNghiKD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayNghiKD" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayNghiKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrangThai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TrangThai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [HoSoDangKy] ([NamHoSo], [SoTT], [DiaBanID], [SoHoSo], [LoaiHoSoID], [NgayCap], [TenCoSoKD], [SoGiayPhepKD], [NgayCapPhepKD], [CoQuanCapKD], [DiaDiem_KD1], [DiaDiem_KD2], [ChuCoSo], [AnhDaiDien], [GioiTinh], [NgaySinh], [SoCMND], [NgayCapCMND], [DonViCap], [DanTocID], [QuocTichID], [DienThoai], [HK_ThuongTru], [HienO], [DiaChi], [MoHinhID], [NganhNgheID], [TrangThaiHS], [NgayNghiKD], [TrangThai], [TongSoTang], [TongSoPhong], [TongSoNhanVien], [TongSoCO2], [TongSoBinhBot], [TongSoLangVoi], [TongSoMayBom], [TongSoNguoi]) VALUES (@NamHoSo, @SoTT, @DiaBanID, @SoHoSo, @LoaiHoSoID, @NgayCap, @TenCoSoKD, @SoGiayPhepKD, @NgayCapPhepKD, @CoQuanCapKD, @DiaDiem_KD1, @DiaDiem_KD2, @ChuCoSo, @AnhDaiDien, @GioiTinh, @NgaySinh, @SoCMND, @NgayCapCMND, @DonViCap, @DanTocID, @QuocTichID, @DienThoai, @HK_ThuongTru, @HienO, @DiaChi, @MoHinhID, @NganhNgheID, @TrangThaiHS, @NgayNghiKD, @TrangThai, @TongSoTang, @TongSoPhong, @TongSoNhanVien, @TongSoCO2, @TongSoBinhBot, @TongSoLangVoi, @TongSoMayBom, @TongSoNguoi);
SELECT ID, NamHoSo, SoTT, DiaBanID, SoHoSo, LoaiHoSoID, NgayCap, TenCoSoKD, SoGiayPhepKD, NgayCapPhepKD, CoQuanCapKD, DiaDiem_KD1, DiaDiem_KD2, ChuCoSo, AnhDaiDien, GioiTinh, NgaySinh, SoCMND, NgayCapCMND, DonViCap, DanTocID, QuocTichID, DienThoai, HK_ThuongTru, HienO, DiaChi, MoHinhID, NganhNgheID, TrangThaiHS, NgayNghiKD, TrangThai, TongSoTang, TongSoPhong, TongSoNhanVien, TongSoCO2, TongSoBinhBot, TongSoLangVoi, TongSoMayBom, TongSoNguoi FROM HoSoDangKy WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NamHoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamHoSo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoTT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoTT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DiaBanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaBanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoHoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoHoSo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LoaiHoSoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoaiHoSoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayCap" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenCoSoKD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenCoSoKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SoGiayPhepKD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoGiayPhepKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayCapPhepKD" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCapPhepKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CoQuanCapKD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CoQuanCapKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaDiem_KD1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaDiem_KD1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaDiem_KD2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaDiem_KD2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ChuCoSo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChuCoSo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnhDaiDien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnhDaiDien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SoCMND" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoCMND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayCapCMND" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCapCMND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DonViCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DanTocID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DanTocID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuocTichID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuocTichID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DienThoai" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HK_ThuongTru" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HK_ThuongTru" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HienO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HienO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MoHinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MoHinhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NganhNgheID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NganhNgheID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TrangThaiHS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TrangThaiHS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayNghiKD" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayNghiKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TrangThai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM HoSoDangKy</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [HoSoDangKy] SET [NamHoSo] = @NamHoSo, [SoTT] = @SoTT, [DiaBanID] = @DiaBanID, [SoHoSo] = @SoHoSo, [LoaiHoSoID] = @LoaiHoSoID, [NgayCap] = @NgayCap, [TenCoSoKD] = @TenCoSoKD, [SoGiayPhepKD] = @SoGiayPhepKD, [NgayCapPhepKD] = @NgayCapPhepKD, [CoQuanCapKD] = @CoQuanCapKD, [DiaDiem_KD1] = @DiaDiem_KD1, [DiaDiem_KD2] = @DiaDiem_KD2, [ChuCoSo] = @ChuCoSo, [AnhDaiDien] = @AnhDaiDien, [GioiTinh] = @GioiTinh, [NgaySinh] = @NgaySinh, [SoCMND] = @SoCMND, [NgayCapCMND] = @NgayCapCMND, [DonViCap] = @DonViCap, [DanTocID] = @DanTocID, [QuocTichID] = @QuocTichID, [DienThoai] = @DienThoai, [HK_ThuongTru] = @HK_ThuongTru, [HienO] = @HienO, [DiaChi] = @DiaChi, [MoHinhID] = @MoHinhID, [NganhNgheID] = @NganhNgheID, [TrangThaiHS] = @TrangThaiHS, [NgayNghiKD] = @NgayNghiKD, [TrangThai] = @TrangThai, [TongSoTang] = @TongSoTang, [TongSoPhong] = @TongSoPhong, [TongSoNhanVien] = @TongSoNhanVien, [TongSoCO2] = @TongSoCO2, [TongSoBinhBot] = @TongSoBinhBot, [TongSoLangVoi] = @TongSoLangVoi, [TongSoMayBom] = @TongSoMayBom, [TongSoNguoi] = @TongSoNguoi WHERE (([ID] = @Original_ID) AND ([NamHoSo] = @Original_NamHoSo) AND ([SoTT] = @Original_SoTT) AND ([DiaBanID] = @Original_DiaBanID) AND ([SoHoSo] = @Original_SoHoSo) AND ([LoaiHoSoID] = @Original_LoaiHoSoID) AND ([NgayCap] = @Original_NgayCap) AND ([TenCoSoKD] = @Original_TenCoSoKD) AND ([SoGiayPhepKD] = @Original_SoGiayPhepKD) AND ([NgayCapPhepKD] = @Original_NgayCapPhepKD) AND ((@IsNull_CoQuanCapKD = 1 AND [CoQuanCapKD] IS NULL) OR ([CoQuanCapKD] = @Original_CoQuanCapKD)) AND ((@IsNull_DiaDiem_KD1 = 1 AND [DiaDiem_KD1] IS NULL) OR ([DiaDiem_KD1] = @Original_DiaDiem_KD1)) AND ((@IsNull_DiaDiem_KD2 = 1 AND [DiaDiem_KD2] IS NULL) OR ([DiaDiem_KD2] = @Original_DiaDiem_KD2)) AND ((@IsNull_ChuCoSo = 1 AND [ChuCoSo] IS NULL) OR ([ChuCoSo] = @Original_ChuCoSo)) AND ((@IsNull_AnhDaiDien = 1 AND [AnhDaiDien] IS NULL) OR ([AnhDaiDien] = @Original_AnhDaiDien)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_SoCMND = 1 AND [SoCMND] IS NULL) OR ([SoCMND] = @Original_SoCMND)) AND ((@IsNull_NgayCapCMND = 1 AND [NgayCapCMND] IS NULL) OR ([NgayCapCMND] = @Original_NgayCapCMND)) AND ((@IsNull_DonViCap = 1 AND [DonViCap] IS NULL) OR ([DonViCap] = @Original_DonViCap)) AND ((@IsNull_DanTocID = 1 AND [DanTocID] IS NULL) OR ([DanTocID] = @Original_DanTocID)) AND ((@IsNull_QuocTichID = 1 AND [QuocTichID] IS NULL) OR ([QuocTichID] = @Original_QuocTichID)) AND ((@IsNull_DienThoai = 1 AND [DienThoai] IS NULL) OR ([DienThoai] = @Original_DienThoai)) AND ((@IsNull_HK_ThuongTru = 1 AND [HK_ThuongTru] IS NULL) OR ([HK_ThuongTru] = @Original_HK_ThuongTru)) AND ((@IsNull_HienO = 1 AND [HienO] IS NULL) OR ([HienO] = @Original_HienO)) AND ((@IsNull_DiaChi = 1 AND [DiaChi] IS NULL) OR ([DiaChi] = @Original_DiaChi)) AND ((@IsNull_MoHinhID = 1 AND [MoHinhID] IS NULL) OR ([MoHinhID] = @Original_MoHinhID)) AND ((@IsNull_NganhNgheID = 1 AND [NganhNgheID] IS NULL) OR ([NganhNgheID] = @Original_NganhNgheID)) AND ((@IsNull_TrangThaiHS = 1 AND [TrangThaiHS] IS NULL) OR ([TrangThaiHS] = @Original_TrangThaiHS)) AND ((@IsNull_NgayNghiKD = 1 AND [NgayNghiKD] IS NULL) OR ([NgayNghiKD] = @Original_NgayNghiKD)) AND ((@IsNull_TrangThai = 1 AND [TrangThai] IS NULL) OR ([TrangThai] = @Original_TrangThai)) AND ((@IsNull_TongSoTang = 1 AND [TongSoTang] IS NULL) OR ([TongSoTang] = @Original_TongSoTang)) AND ((@IsNull_TongSoPhong = 1 AND [TongSoPhong] IS NULL) OR ([TongSoPhong] = @Original_TongSoPhong)) AND ((@IsNull_TongSoNhanVien = 1 AND [TongSoNhanVien] IS NULL) OR ([TongSoNhanVien] = @Original_TongSoNhanVien)) AND ((@IsNull_TongSoCO2 = 1 AND [TongSoCO2] IS NULL) OR ([TongSoCO2] = @Original_TongSoCO2)) AND ((@IsNull_TongSoBinhBot = 1 AND [TongSoBinhBot] IS NULL) OR ([TongSoBinhBot] = @Original_TongSoBinhBot)) AND ((@IsNull_TongSoLangVoi = 1 AND [TongSoLangVoi] IS NULL) OR ([TongSoLangVoi] = @Original_TongSoLangVoi)) AND ((@IsNull_TongSoMayBom = 1 AND [TongSoMayBom] IS NULL) OR ([TongSoMayBom] = @Original_TongSoMayBom)) AND ((@IsNull_TongSoNguoi = 1 AND [TongSoNguoi] IS NULL) OR ([TongSoNguoi] = @Original_TongSoNguoi)));
SELECT ID, NamHoSo, SoTT, DiaBanID, SoHoSo, LoaiHoSoID, NgayCap, TenCoSoKD, SoGiayPhepKD, NgayCapPhepKD, CoQuanCapKD, DiaDiem_KD1, DiaDiem_KD2, ChuCoSo, AnhDaiDien, GioiTinh, NgaySinh, SoCMND, NgayCapCMND, DonViCap, DanTocID, QuocTichID, DienThoai, HK_ThuongTru, HienO, DiaChi, MoHinhID, NganhNgheID, TrangThaiHS, NgayNghiKD, TrangThai, TongSoTang, TongSoPhong, TongSoNhanVien, TongSoCO2, TongSoBinhBot, TongSoLangVoi, TongSoMayBom, TongSoNguoi FROM HoSoDangKy WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NamHoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamHoSo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoTT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoTT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DiaBanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaBanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoHoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoHoSo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LoaiHoSoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoaiHoSoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayCap" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenCoSoKD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenCoSoKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SoGiayPhepKD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoGiayPhepKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayCapPhepKD" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCapPhepKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CoQuanCapKD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CoQuanCapKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaDiem_KD1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaDiem_KD1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaDiem_KD2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaDiem_KD2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ChuCoSo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChuCoSo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnhDaiDien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnhDaiDien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SoCMND" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoCMND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayCapCMND" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCapCMND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DonViCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DanTocID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DanTocID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuocTichID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuocTichID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DienThoai" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HK_ThuongTru" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HK_ThuongTru" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HienO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HienO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MoHinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MoHinhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NganhNgheID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NganhNgheID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TrangThaiHS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TrangThaiHS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayNghiKD" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayNghiKD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TrangThai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NamHoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamHoSo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoTT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoTT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DiaBanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaBanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoHoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoHoSo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LoaiHoSoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LoaiHoSoID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayCap" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenCoSoKD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenCoSoKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SoGiayPhepKD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoGiayPhepKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayCapPhepKD" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCapPhepKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CoQuanCapKD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoQuanCapKD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CoQuanCapKD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CoQuanCapKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaDiem_KD1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaDiem_KD1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaDiem_KD1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaDiem_KD1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaDiem_KD2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaDiem_KD2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaDiem_KD2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaDiem_KD2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChuCoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChuCoSo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ChuCoSo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChuCoSo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnhDaiDien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnhDaiDien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AnhDaiDien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnhDaiDien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoCMND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoCMND" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SoCMND" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoCMND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayCapCMND" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayCapCMND" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayCapCMND" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayCapCMND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DonViCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DonViCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DonViCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DanTocID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DanTocID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DanTocID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DanTocID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QuocTichID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuocTichID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuocTichID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuocTichID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DienThoai" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HK_ThuongTru" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HK_ThuongTru" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HK_ThuongTru" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HK_ThuongTru" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HienO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HienO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HienO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HienO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MoHinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MoHinhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MoHinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MoHinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NganhNgheID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NganhNgheID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NganhNgheID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NganhNgheID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrangThaiHS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThaiHS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TrangThaiHS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TrangThaiHS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayNghiKD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayNghiKD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayNghiKD" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayNghiKD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrangThai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TrangThai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="QLKD.dbo.HoSoDangKy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="NamHoSo" DataSetColumn="NamHoSo" />
              <Mapping SourceColumn="SoTT" DataSetColumn="SoTT" />
              <Mapping SourceColumn="DiaBanID" DataSetColumn="DiaBanID" />
              <Mapping SourceColumn="SoHoSo" DataSetColumn="SoHoSo" />
              <Mapping SourceColumn="LoaiHoSoID" DataSetColumn="LoaiHoSoID" />
              <Mapping SourceColumn="NgayCap" DataSetColumn="NgayCap" />
              <Mapping SourceColumn="TenCoSoKD" DataSetColumn="TenCoSoKD" />
              <Mapping SourceColumn="SoGiayPhepKD" DataSetColumn="SoGiayPhepKD" />
              <Mapping SourceColumn="NgayCapPhepKD" DataSetColumn="NgayCapPhepKD" />
              <Mapping SourceColumn="CoQuanCapKD" DataSetColumn="CoQuanCapKD" />
              <Mapping SourceColumn="DiaDiem_KD1" DataSetColumn="DiaDiem_KD1" />
              <Mapping SourceColumn="DiaDiem_KD2" DataSetColumn="DiaDiem_KD2" />
              <Mapping SourceColumn="ChuCoSo" DataSetColumn="ChuCoSo" />
              <Mapping SourceColumn="AnhDaiDien" DataSetColumn="AnhDaiDien" />
              <Mapping SourceColumn="GioiTinh" DataSetColumn="GioiTinh" />
              <Mapping SourceColumn="NgaySinh" DataSetColumn="NgaySinh" />
              <Mapping SourceColumn="SoCMND" DataSetColumn="SoCMND" />
              <Mapping SourceColumn="NgayCapCMND" DataSetColumn="NgayCapCMND" />
              <Mapping SourceColumn="DonViCap" DataSetColumn="DonViCap" />
              <Mapping SourceColumn="DanTocID" DataSetColumn="DanTocID" />
              <Mapping SourceColumn="QuocTichID" DataSetColumn="QuocTichID" />
              <Mapping SourceColumn="DienThoai" DataSetColumn="DienThoai" />
              <Mapping SourceColumn="HK_ThuongTru" DataSetColumn="HK_ThuongTru" />
              <Mapping SourceColumn="HienO" DataSetColumn="HienO" />
              <Mapping SourceColumn="DiaChi" DataSetColumn="DiaChi" />
              <Mapping SourceColumn="MoHinhID" DataSetColumn="MoHinhID" />
              <Mapping SourceColumn="NganhNgheID" DataSetColumn="NganhNgheID" />
              <Mapping SourceColumn="TrangThaiHS" DataSetColumn="TrangThaiHS" />
              <Mapping SourceColumn="NgayNghiKD" DataSetColumn="NgayNghiKD" />
              <Mapping SourceColumn="TrangThai" DataSetColumn="TrangThai" />
              <Mapping SourceColumn="TongSoTang" DataSetColumn="TongSoTang" />
              <Mapping SourceColumn="TongSoPhong" DataSetColumn="TongSoPhong" />
              <Mapping SourceColumn="TongSoNhanVien" DataSetColumn="TongSoNhanVien" />
              <Mapping SourceColumn="TongSoCO2" DataSetColumn="TongSoCO2" />
              <Mapping SourceColumn="TongSoBinhBot" DataSetColumn="TongSoBinhBot" />
              <Mapping SourceColumn="TongSoLangVoi" DataSetColumn="TongSoLangVoi" />
              <Mapping SourceColumn="TongSoMayBom" DataSetColumn="TongSoMayBom" />
              <Mapping SourceColumn="TongSoNguoi" DataSetColumn="TongSoNguoi" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QuyMoHoatDongTableAdapter" GeneratorDataComponentClassName="QuyMoHoatDongTableAdapter" Name="QuyMoHoatDong" UserDataComponentName="QuyMoHoatDongTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="QLKDConnectionString (Settings)" DbObjectName="QLKD.dbo.HoSoDangKy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [HoSoDangKy] WHERE (([ID] = @Original_HoSoDangKyID) AND ((@IsNull_TongSoTang = 1 AND [TongSoTang] IS NULL) OR ([TongSoTang] = @Original_TongSoTang)) AND ((@IsNull_TongSoPhong = 1 AND [TongSoPhong] IS NULL) OR ([TongSoPhong] = @Original_TongSoPhong)) AND ((@IsNull_TongSoNhanVien = 1 AND [TongSoNhanVien] IS NULL) OR ([TongSoNhanVien] = @Original_TongSoNhanVien)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HoSoDangKyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoSoDangKyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select ID HoSoDangKyID,TongSoTang, TongSoPhong, TongSoNhanVien from HoSoDangKy</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [HoSoDangKy] SET [TongSoTang] = @TongSoTang, [TongSoPhong] = @TongSoPhong, [TongSoNhanVien] = @TongSoNhanVien WHERE (([ID] = @Original_HoSoDangKyID) AND ((@IsNull_TongSoTang = 1 AND [TongSoTang] IS NULL) OR ([TongSoTang] = @Original_TongSoTang)) AND ((@IsNull_TongSoPhong = 1 AND [TongSoPhong] IS NULL) OR ([TongSoPhong] = @Original_TongSoPhong)) AND ((@IsNull_TongSoNhanVien = 1 AND [TongSoNhanVien] IS NULL) OR ([TongSoNhanVien] = @Original_TongSoNhanVien)));
SELECT ID AS HoSoDangKyID, TongSoTang, TongSoPhong, TongSoNhanVien FROM HoSoDangKy WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HoSoDangKyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoSoDangKyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoTang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoTang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoPhong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoNhanVien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="QLKD.dbo.HoSoDangKy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="HoSoDangKyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="HoSoDangKyID" DataSetColumn="HoSoDangKyID" />
              <Mapping SourceColumn="TongSoTang" DataSetColumn="TongSoTang" />
              <Mapping SourceColumn="TongSoPhong" DataSetColumn="TongSoPhong" />
              <Mapping SourceColumn="TongSoNhanVien" DataSetColumn="TongSoNhanVien" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PCCCTableAdapter" GeneratorDataComponentClassName="PCCCTableAdapter" Name="PCCC" UserDataComponentName="PCCCTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="QLKDConnectionString (Settings)" DbObjectName="QLKD.dbo.HoSoDangKy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [HoSoDangKy] WHERE (([ID] = @Original_HoSoDangKyID) AND ((@IsNull_TongSoCO2 = 1 AND [TongSoCO2] IS NULL) OR ([TongSoCO2] = @Original_TongSoCO2)) AND ((@IsNull_TongSoBinhBot = 1 AND [TongSoBinhBot] IS NULL) OR ([TongSoBinhBot] = @Original_TongSoBinhBot)) AND ((@IsNull_TongSoLangVoi = 1 AND [TongSoLangVoi] IS NULL) OR ([TongSoLangVoi] = @Original_TongSoLangVoi)) AND ((@IsNull_TongSoMayBom = 1 AND [TongSoMayBom] IS NULL) OR ([TongSoMayBom] = @Original_TongSoMayBom)) AND ((@IsNull_TongSoNguoi = 1 AND [TongSoNguoi] IS NULL) OR ([TongSoNguoi] = @Original_TongSoNguoi)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HoSoDangKyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoSoDangKyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select ID HoSoDangKyID, TongSoCO2, TongSoBinhBot, TongSoLangVoi, TongSoMayBom, TongSoNguoi  from HoSoDangKy</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [HoSoDangKy] SET [TongSoCO2] = @TongSoCO2, [TongSoBinhBot] = @TongSoBinhBot, [TongSoLangVoi] = @TongSoLangVoi, [TongSoMayBom] = @TongSoMayBom, [TongSoNguoi] = @TongSoNguoi WHERE (([ID] = @Original_HoSoDangKyID) AND ((@IsNull_TongSoCO2 = 1 AND [TongSoCO2] IS NULL) OR ([TongSoCO2] = @Original_TongSoCO2)) AND ((@IsNull_TongSoBinhBot = 1 AND [TongSoBinhBot] IS NULL) OR ([TongSoBinhBot] = @Original_TongSoBinhBot)) AND ((@IsNull_TongSoLangVoi = 1 AND [TongSoLangVoi] IS NULL) OR ([TongSoLangVoi] = @Original_TongSoLangVoi)) AND ((@IsNull_TongSoMayBom = 1 AND [TongSoMayBom] IS NULL) OR ([TongSoMayBom] = @Original_TongSoMayBom)) AND ((@IsNull_TongSoNguoi = 1 AND [TongSoNguoi] IS NULL) OR ([TongSoNguoi] = @Original_TongSoNguoi)));
SELECT ID AS HoSoDangKyID, TongSoCO2, TongSoBinhBot, TongSoLangVoi, TongSoMayBom, TongSoNguoi FROM HoSoDangKy WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HoSoDangKyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoSoDangKyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoCO2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoCO2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoBinhBot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoBinhBot" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoLangVoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoLangVoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoMayBom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoMayBom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TongSoNguoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TongSoNguoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="QLKD.dbo.HoSoDangKy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="HoSoDangKyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="HoSoDangKyID" DataSetColumn="HoSoDangKyID" />
              <Mapping SourceColumn="TongSoCO2" DataSetColumn="TongSoCO2" />
              <Mapping SourceColumn="TongSoBinhBot" DataSetColumn="TongSoBinhBot" />
              <Mapping SourceColumn="TongSoLangVoi" DataSetColumn="TongSoLangVoi" />
              <Mapping SourceColumn="TongSoMayBom" DataSetColumn="TongSoMayBom" />
              <Mapping SourceColumn="TongSoNguoi" DataSetColumn="TongSoNguoi" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="XuLyViPhamTableAdapter" GeneratorDataComponentClassName="XuLyViPhamTableAdapter" Name="XuLyViPham" UserDataComponentName="XuLyViPhamTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="QLKDConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT A.*, B.SoTien, B.TenMuc FROM XuLyViPham A INNER JOIN DMMucXuPhat B ON A.MucXuPhatID = B.ID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="HoSoID" DataSetColumn="HoSoID" />
              <Mapping SourceColumn="SoTT" DataSetColumn="SoTT" />
              <Mapping SourceColumn="NgayXuLy" DataSetColumn="NgayXuLy" />
              <Mapping SourceColumn="HanhViiPham" DataSetColumn="HanhViiPham" />
              <Mapping SourceColumn="DonViXuLy" DataSetColumn="DonViXuLy" />
              <Mapping SourceColumn="MucXuPhatID" DataSetColumn="MucXuPhatID" />
              <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
              <Mapping SourceColumn="SoTien" DataSetColumn="SoTien" />
              <Mapping SourceColumn="TenMuc" DataSetColumn="TenMuc" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DSHoSo" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DSHoSo" msprop:Generator_DataSetName="DSHoSo" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="HoSoDangKy" msprop:Generator_UserTableName="HoSoDangKy" msprop:Generator_RowDeletedName="HoSoDangKyRowDeleted" msprop:Generator_RowChangedName="HoSoDangKyRowChanged" msprop:Generator_RowClassName="HoSoDangKyRow" msprop:Generator_RowChangingName="HoSoDangKyRowChanging" msprop:Generator_RowEvArgName="HoSoDangKyRowChangeEvent" msprop:Generator_RowEvHandlerName="HoSoDangKyRowChangeEventHandler" msprop:Generator_TableClassName="HoSoDangKyDataTable" msprop:Generator_TableVarName="tableHoSoDangKy" msprop:Generator_RowDeletingName="HoSoDangKyRowDeleting" msprop:Generator_TablePropName="HoSoDangKy">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="NamHoSo" msprop:Generator_UserColumnName="NamHoSo" msprop:Generator_ColumnVarNameInTable="columnNamHoSo" msprop:Generator_ColumnPropNameInRow="NamHoSo" msprop:Generator_ColumnPropNameInTable="NamHoSoColumn" type="xs:int" />
              <xs:element name="SoTT" msprop:Generator_UserColumnName="SoTT" msprop:Generator_ColumnVarNameInTable="columnSoTT" msprop:Generator_ColumnPropNameInRow="SoTT" msprop:Generator_ColumnPropNameInTable="SoTTColumn" type="xs:int" />
              <xs:element name="DiaBanID" msprop:Generator_UserColumnName="DiaBanID" msprop:Generator_ColumnVarNameInTable="columnDiaBanID" msprop:Generator_ColumnPropNameInRow="DiaBanID" msprop:Generator_ColumnPropNameInTable="DiaBanIDColumn" type="xs:int" />
              <xs:element name="SoHoSo" msprop:Generator_UserColumnName="SoHoSo" msprop:Generator_ColumnVarNameInTable="columnSoHoSo" msprop:Generator_ColumnPropNameInRow="SoHoSo" msprop:Generator_ColumnPropNameInTable="SoHoSoColumn" type="xs:int" />
              <xs:element name="LoaiHoSoID" msprop:Generator_UserColumnName="LoaiHoSoID" msprop:Generator_ColumnVarNameInTable="columnLoaiHoSoID" msprop:Generator_ColumnPropNameInRow="LoaiHoSoID" msprop:Generator_ColumnPropNameInTable="LoaiHoSoIDColumn" type="xs:int" />
              <xs:element name="NgayCap" msprop:Generator_UserColumnName="NgayCap" msprop:Generator_ColumnVarNameInTable="columnNgayCap" msprop:Generator_ColumnPropNameInRow="NgayCap" msprop:Generator_ColumnPropNameInTable="NgayCapColumn" type="xs:dateTime" />
              <xs:element name="TenCoSoKD" msprop:Generator_UserColumnName="TenCoSoKD" msprop:Generator_ColumnVarNameInTable="columnTenCoSoKD" msprop:Generator_ColumnPropNameInRow="TenCoSoKD" msprop:Generator_ColumnPropNameInTable="TenCoSoKDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SoGiayPhepKD" msprop:Generator_UserColumnName="SoGiayPhepKD" msprop:Generator_ColumnVarNameInTable="columnSoGiayPhepKD" msprop:Generator_ColumnPropNameInRow="SoGiayPhepKD" msprop:Generator_ColumnPropNameInTable="SoGiayPhepKDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NgayCapPhepKD" msprop:Generator_UserColumnName="NgayCapPhepKD" msprop:Generator_ColumnVarNameInTable="columnNgayCapPhepKD" msprop:Generator_ColumnPropNameInRow="NgayCapPhepKD" msprop:Generator_ColumnPropNameInTable="NgayCapPhepKDColumn" type="xs:dateTime" />
              <xs:element name="CoQuanCapKD" msprop:Generator_UserColumnName="CoQuanCapKD" msprop:Generator_ColumnVarNameInTable="columnCoQuanCapKD" msprop:Generator_ColumnPropNameInRow="CoQuanCapKD" msprop:Generator_ColumnPropNameInTable="CoQuanCapKDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DiaDiem_KD1" msprop:Generator_UserColumnName="DiaDiem_KD1" msprop:Generator_ColumnVarNameInTable="columnDiaDiem_KD1" msprop:Generator_ColumnPropNameInRow="DiaDiem_KD1" msprop:Generator_ColumnPropNameInTable="DiaDiem_KD1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DiaDiem_KD2" msprop:Generator_UserColumnName="DiaDiem_KD2" msprop:Generator_ColumnVarNameInTable="columnDiaDiem_KD2" msprop:Generator_ColumnPropNameInRow="DiaDiem_KD2" msprop:Generator_ColumnPropNameInTable="DiaDiem_KD2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ChuCoSo" msprop:Generator_UserColumnName="ChuCoSo" msprop:Generator_ColumnVarNameInTable="columnChuCoSo" msprop:Generator_ColumnPropNameInRow="ChuCoSo" msprop:Generator_ColumnPropNameInTable="ChuCoSoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AnhDaiDien" msprop:Generator_UserColumnName="AnhDaiDien" msprop:Generator_ColumnVarNameInTable="columnAnhDaiDien" msprop:Generator_ColumnPropNameInRow="AnhDaiDien" msprop:Generator_ColumnPropNameInTable="AnhDaiDienColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GioiTinh" msprop:Generator_UserColumnName="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="NgaySinh" msprop:Generator_UserColumnName="NgaySinh" msprop:Generator_ColumnVarNameInTable="columnNgaySinh" msprop:Generator_ColumnPropNameInRow="NgaySinh" msprop:Generator_ColumnPropNameInTable="NgaySinhColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="SoCMND" msprop:Generator_UserColumnName="SoCMND" msprop:Generator_ColumnVarNameInTable="columnSoCMND" msprop:Generator_ColumnPropNameInRow="SoCMND" msprop:Generator_ColumnPropNameInTable="SoCMNDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NgayCapCMND" msprop:Generator_UserColumnName="NgayCapCMND" msprop:Generator_ColumnVarNameInTable="columnNgayCapCMND" msprop:Generator_ColumnPropNameInRow="NgayCapCMND" msprop:Generator_ColumnPropNameInTable="NgayCapCMNDColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DonViCap" msprop:Generator_UserColumnName="DonViCap" msprop:Generator_ColumnVarNameInTable="columnDonViCap" msprop:Generator_ColumnPropNameInRow="DonViCap" msprop:Generator_ColumnPropNameInTable="DonViCapColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DanTocID" msprop:Generator_UserColumnName="DanTocID" msprop:Generator_ColumnVarNameInTable="columnDanTocID" msprop:Generator_ColumnPropNameInRow="DanTocID" msprop:Generator_ColumnPropNameInTable="DanTocIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="QuocTichID" msprop:Generator_UserColumnName="QuocTichID" msprop:Generator_ColumnVarNameInTable="columnQuocTichID" msprop:Generator_ColumnPropNameInRow="QuocTichID" msprop:Generator_ColumnPropNameInTable="QuocTichIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DienThoai" msprop:Generator_UserColumnName="DienThoai" msprop:Generator_ColumnVarNameInTable="columnDienThoai" msprop:Generator_ColumnPropNameInRow="DienThoai" msprop:Generator_ColumnPropNameInTable="DienThoaiColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HK_ThuongTru" msprop:Generator_UserColumnName="HK_ThuongTru" msprop:Generator_ColumnVarNameInTable="columnHK_ThuongTru" msprop:Generator_ColumnPropNameInRow="HK_ThuongTru" msprop:Generator_ColumnPropNameInTable="HK_ThuongTruColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HienO" msprop:Generator_UserColumnName="HienO" msprop:Generator_ColumnVarNameInTable="columnHienO" msprop:Generator_ColumnPropNameInRow="HienO" msprop:Generator_ColumnPropNameInTable="HienOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DiaChi" msprop:Generator_UserColumnName="DiaChi" msprop:Generator_ColumnVarNameInTable="columnDiaChi" msprop:Generator_ColumnPropNameInRow="DiaChi" msprop:Generator_ColumnPropNameInTable="DiaChiColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MoHinhID" msprop:Generator_UserColumnName="MoHinhID" msprop:Generator_ColumnVarNameInTable="columnMoHinhID" msprop:Generator_ColumnPropNameInRow="MoHinhID" msprop:Generator_ColumnPropNameInTable="MoHinhIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NganhNgheID" msprop:Generator_UserColumnName="NganhNgheID" msprop:Generator_ColumnVarNameInTable="columnNganhNgheID" msprop:Generator_ColumnPropNameInRow="NganhNgheID" msprop:Generator_ColumnPropNameInTable="NganhNgheIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TrangThaiHS" msprop:Generator_UserColumnName="TrangThaiHS" msprop:Generator_ColumnVarNameInTable="columnTrangThaiHS" msprop:Generator_ColumnPropNameInRow="TrangThaiHS" msprop:Generator_ColumnPropNameInTable="TrangThaiHSColumn" type="xs:short" minOccurs="0" />
              <xs:element name="NgayNghiKD" msprop:Generator_UserColumnName="NgayNghiKD" msprop:Generator_ColumnVarNameInTable="columnNgayNghiKD" msprop:Generator_ColumnPropNameInRow="NgayNghiKD" msprop:Generator_ColumnPropNameInTable="NgayNghiKDColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TrangThai" msprop:Generator_UserColumnName="TrangThai" msprop:Generator_ColumnVarNameInTable="columnTrangThai" msprop:Generator_ColumnPropNameInRow="TrangThai" msprop:Generator_ColumnPropNameInTable="TrangThaiColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoTang" msprop:Generator_UserColumnName="TongSoTang" msprop:Generator_ColumnVarNameInTable="columnTongSoTang" msprop:Generator_ColumnPropNameInRow="TongSoTang" msprop:Generator_ColumnPropNameInTable="TongSoTangColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoPhong" msprop:Generator_UserColumnName="TongSoPhong" msprop:Generator_ColumnVarNameInTable="columnTongSoPhong" msprop:Generator_ColumnPropNameInRow="TongSoPhong" msprop:Generator_ColumnPropNameInTable="TongSoPhongColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoNhanVien" msprop:Generator_UserColumnName="TongSoNhanVien" msprop:Generator_ColumnVarNameInTable="columnTongSoNhanVien" msprop:Generator_ColumnPropNameInRow="TongSoNhanVien" msprop:Generator_ColumnPropNameInTable="TongSoNhanVienColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoCO2" msprop:Generator_UserColumnName="TongSoCO2" msprop:Generator_ColumnVarNameInTable="columnTongSoCO2" msprop:Generator_ColumnPropNameInRow="TongSoCO2" msprop:Generator_ColumnPropNameInTable="TongSoCO2Column" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoBinhBot" msprop:Generator_UserColumnName="TongSoBinhBot" msprop:Generator_ColumnVarNameInTable="columnTongSoBinhBot" msprop:Generator_ColumnPropNameInRow="TongSoBinhBot" msprop:Generator_ColumnPropNameInTable="TongSoBinhBotColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoLangVoi" msprop:Generator_UserColumnName="TongSoLangVoi" msprop:Generator_ColumnVarNameInTable="columnTongSoLangVoi" msprop:Generator_ColumnPropNameInRow="TongSoLangVoi" msprop:Generator_ColumnPropNameInTable="TongSoLangVoiColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoMayBom" msprop:Generator_UserColumnName="TongSoMayBom" msprop:Generator_ColumnVarNameInTable="columnTongSoMayBom" msprop:Generator_ColumnPropNameInRow="TongSoMayBom" msprop:Generator_ColumnPropNameInTable="TongSoMayBomColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoNguoi" msprop:Generator_UserColumnName="TongSoNguoi" msprop:Generator_ColumnVarNameInTable="columnTongSoNguoi" msprop:Generator_ColumnPropNameInRow="TongSoNguoi" msprop:Generator_ColumnPropNameInTable="TongSoNguoiColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="QuyMoHoatDong" msprop:Generator_UserTableName="QuyMoHoatDong" msprop:Generator_RowDeletedName="QuyMoHoatDongRowDeleted" msprop:Generator_RowChangedName="QuyMoHoatDongRowChanged" msprop:Generator_RowClassName="QuyMoHoatDongRow" msprop:Generator_RowChangingName="QuyMoHoatDongRowChanging" msprop:Generator_RowEvArgName="QuyMoHoatDongRowChangeEvent" msprop:Generator_RowEvHandlerName="QuyMoHoatDongRowChangeEventHandler" msprop:Generator_TableClassName="QuyMoHoatDongDataTable" msprop:Generator_TableVarName="tableQuyMoHoatDong" msprop:Generator_RowDeletingName="QuyMoHoatDongRowDeleting" msprop:Generator_TablePropName="QuyMoHoatDong">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="HoSoDangKyID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="HoSoDangKyID" msprop:Generator_ColumnVarNameInTable="columnHoSoDangKyID" msprop:Generator_ColumnPropNameInRow="HoSoDangKyID" msprop:Generator_ColumnPropNameInTable="HoSoDangKyIDColumn" type="xs:int" />
              <xs:element name="TongSoTang" msprop:Generator_UserColumnName="TongSoTang" msprop:Generator_ColumnVarNameInTable="columnTongSoTang" msprop:Generator_ColumnPropNameInRow="TongSoTang" msprop:Generator_ColumnPropNameInTable="TongSoTangColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoPhong" msprop:Generator_UserColumnName="TongSoPhong" msprop:Generator_ColumnVarNameInTable="columnTongSoPhong" msprop:Generator_ColumnPropNameInRow="TongSoPhong" msprop:Generator_ColumnPropNameInTable="TongSoPhongColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoNhanVien" msprop:Generator_UserColumnName="TongSoNhanVien" msprop:Generator_ColumnVarNameInTable="columnTongSoNhanVien" msprop:Generator_ColumnPropNameInRow="TongSoNhanVien" msprop:Generator_ColumnPropNameInTable="TongSoNhanVienColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PCCC" msprop:Generator_UserTableName="PCCC" msprop:Generator_RowDeletedName="PCCCRowDeleted" msprop:Generator_RowChangedName="PCCCRowChanged" msprop:Generator_RowClassName="PCCCRow" msprop:Generator_RowChangingName="PCCCRowChanging" msprop:Generator_RowEvArgName="PCCCRowChangeEvent" msprop:Generator_RowEvHandlerName="PCCCRowChangeEventHandler" msprop:Generator_TableClassName="PCCCDataTable" msprop:Generator_TableVarName="tablePCCC" msprop:Generator_RowDeletingName="PCCCRowDeleting" msprop:Generator_TablePropName="PCCC">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="HoSoDangKyID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="HoSoDangKyID" msprop:Generator_ColumnVarNameInTable="columnHoSoDangKyID" msprop:Generator_ColumnPropNameInRow="HoSoDangKyID" msprop:Generator_ColumnPropNameInTable="HoSoDangKyIDColumn" type="xs:int" />
              <xs:element name="TongSoCO2" msprop:Generator_UserColumnName="TongSoCO2" msprop:Generator_ColumnVarNameInTable="columnTongSoCO2" msprop:Generator_ColumnPropNameInRow="TongSoCO2" msprop:Generator_ColumnPropNameInTable="TongSoCO2Column" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoBinhBot" msprop:Generator_UserColumnName="TongSoBinhBot" msprop:Generator_ColumnVarNameInTable="columnTongSoBinhBot" msprop:Generator_ColumnPropNameInRow="TongSoBinhBot" msprop:Generator_ColumnPropNameInTable="TongSoBinhBotColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoLangVoi" msprop:Generator_UserColumnName="TongSoLangVoi" msprop:Generator_ColumnVarNameInTable="columnTongSoLangVoi" msprop:Generator_ColumnPropNameInRow="TongSoLangVoi" msprop:Generator_ColumnPropNameInTable="TongSoLangVoiColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoMayBom" msprop:Generator_UserColumnName="TongSoMayBom" msprop:Generator_ColumnVarNameInTable="columnTongSoMayBom" msprop:Generator_ColumnPropNameInRow="TongSoMayBom" msprop:Generator_ColumnPropNameInTable="TongSoMayBomColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TongSoNguoi" msprop:Generator_UserColumnName="TongSoNguoi" msprop:Generator_ColumnVarNameInTable="columnTongSoNguoi" msprop:Generator_ColumnPropNameInRow="TongSoNguoi" msprop:Generator_ColumnPropNameInTable="TongSoNguoiColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="XuLyViPham" msprop:Generator_UserTableName="XuLyViPham" msprop:Generator_RowDeletedName="XuLyViPhamRowDeleted" msprop:Generator_TableClassName="XuLyViPhamDataTable" msprop:Generator_RowChangedName="XuLyViPhamRowChanged" msprop:Generator_RowClassName="XuLyViPhamRow" msprop:Generator_RowChangingName="XuLyViPhamRowChanging" msprop:Generator_RowEvArgName="XuLyViPhamRowChangeEvent" msprop:Generator_RowEvHandlerName="XuLyViPhamRowChangeEventHandler" msprop:Generator_TablePropName="XuLyViPham" msprop:Generator_TableVarName="tableXuLyViPham" msprop:Generator_RowDeletingName="XuLyViPhamRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="HoSoID" msprop:Generator_UserColumnName="HoSoID" msprop:Generator_ColumnPropNameInRow="HoSoID" msprop:Generator_ColumnVarNameInTable="columnHoSoID" msprop:Generator_ColumnPropNameInTable="HoSoIDColumn" type="xs:int" />
              <xs:element name="SoTT" msprop:Generator_UserColumnName="SoTT" msprop:Generator_ColumnPropNameInRow="SoTT" msprop:Generator_ColumnVarNameInTable="columnSoTT" msprop:Generator_ColumnPropNameInTable="SoTTColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NgayXuLy" msprop:Generator_UserColumnName="NgayXuLy" msprop:Generator_ColumnPropNameInRow="NgayXuLy" msprop:Generator_ColumnVarNameInTable="columnNgayXuLy" msprop:Generator_ColumnPropNameInTable="NgayXuLyColumn" type="xs:dateTime" />
              <xs:element name="HanhViiPham" msprop:Generator_UserColumnName="HanhViiPham" msprop:Generator_ColumnPropNameInRow="HanhViiPham" msprop:Generator_ColumnVarNameInTable="columnHanhViiPham" msprop:Generator_ColumnPropNameInTable="HanhViiPhamColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DonViXuLy" msprop:Generator_UserColumnName="DonViXuLy" msprop:Generator_ColumnPropNameInRow="DonViXuLy" msprop:Generator_ColumnVarNameInTable="columnDonViXuLy" msprop:Generator_ColumnPropNameInTable="DonViXuLyColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MucXuPhatID" msprop:Generator_UserColumnName="MucXuPhatID" msprop:Generator_ColumnPropNameInRow="MucXuPhatID" msprop:Generator_ColumnVarNameInTable="columnMucXuPhatID" msprop:Generator_ColumnPropNameInTable="MucXuPhatIDColumn" type="xs:int" />
              <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SoTien" msprop:Generator_UserColumnName="SoTien" msprop:Generator_ColumnPropNameInRow="SoTien" msprop:Generator_ColumnVarNameInTable="columnSoTien" msprop:Generator_ColumnPropNameInTable="SoTienColumn" type="xs:int" />
              <xs:element name="TenMuc" msprop:Generator_UserColumnName="TenMuc" msprop:Generator_ColumnPropNameInRow="TenMuc" msprop:Generator_ColumnVarNameInTable="columnTenMuc" msprop:Generator_ColumnPropNameInTable="TenMucColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:HoSoDangKy" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="QuyMoHoatDong_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:QuyMoHoatDong" />
      <xs:field xpath="mstns:HoSoDangKyID" />
    </xs:unique>
    <xs:unique name="PCCC_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PCCC" />
      <xs:field xpath="mstns:HoSoDangKyID" />
    </xs:unique>
    <xs:unique name="XuLyViPham_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:XuLyViPham" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>